*correctly distribute the stocks of auto and pauto
splevelup kdepvar, from(division) to(BvD year ctryid)

*calculate new stocks and idicators for 0 stocks
replace stockauto95 = ln(1+kdepvar_auto95) 
replace stockauto95zero = kdepvar_auto95 ==0
replace stockpauto95 = ln(1+kdepvar_pauto95)  
replace stockpauto95zero = kdepvar_pauto95==0


*drop temporary variable
drop kdepvar_*